Creating Seeds

Create your seeds in a .csv or .txt file with headers that map to the values in the Fields tab.

Before you begin

Regardless of what type of tactic you are inserting the seeds into, you first have to upload a seeds file to your tactic. Before you can use the Seeds tab on File, Send a Message, or in an Omni Tactic you must create a comma separated and double quoted (if needed) .csv or .txt seed file and save it in the Campaign Manager document explorer.

Procedure

1. Create the .csv file:

The header row column formats of the .csv file must map to the columns on the database (case sensitive). You must have a column in the uploaded seeds file for every data type you are mapping to your database.

The following example shows a .csv file with database fields, a variable, attributes and engineered columns:

You must specify the various data types in the .csv seeds file header row you are mapping to the database in the following formats:

2. Upload the .csv file to the Campaign Manager document explorer (for more information, see Uploading files).
3. Click the Seeds tab.
4. Click the Browse button to locate your .csv or .txt file in the document explorer.
5. Select the file and click Select.

If the seeds file maps correctly, a green check mark is displayed to the right of the Browse button:

If the seeds file is mapped incorrectly, a red cross is displayed next to the Browse button:

A seeds file does not map correctly when:

• There is no header row
• The header rows are set up incorrectly
• The file format is not a comma delimited and double quote qualified .txt or .csv file extension

Results

When you have uploaded the seeds file, one of the following messages appears regarding seed file mapping:

Message	Description
None of the Seeds map to a field	There are no fields in either the Fields or Send a Message tab on the tactic. Add the fields on the relevant tab and click the Refresh button .
Seeds Mapped	All columns used in the seeds file are used in the Fields tab or Send a Message tab on the tactic. The campaign will validate successfully.
Seeds mapped. One or more Seeds are unused	Not all columns in the seeds file are used in the Fields tab or Send a Message tab on the tactic. The campaign will validate successfully.
One or more Seeds failed. One or more Seeds are unused	There are fields specified under the Fields tab that do not appear in the seeds file. Campaign validation will fail.

Example of seed file mapping

The screen shot below shows a seeds file:

When you select this seed file, the mapping is successful, even though there are two columns in the seeds file that are not in the fields ('title' and 'EngineeredCol'). The "Seeds mapped. One or more Seeds are unused" message is displayed because of these two extra columns in the seeds file. Here is the mapping result under the Seeds tab for the above seeds file:

Below are the corresponding fields under the Fields tab. You can see that 'title' and 'EngineeredCol' are not specified fields, however this does not cause a problem and the campaign can be validated:

• Seeds
  • Creating Seeds
  • Seeds in Cells